package com.github.edu.repair.manager.domain;

import com.github.admin.edu.orm.repository.CustomRepository;
import com.github.edu.repair.manager.entity.TBxGzms;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

/**
 * Created by IntelliJ IDEA.
 * user:wangj
 * date:2018/8/20
 * Time: 21:11
 */
public interface GzmsServerDomain extends CustomRepository<TBxGzms,Integer> {


    @Query("select t from TBxGzms t where t.fwdl=:fwdl and t.fwfl=:fwfl and t.sfqy =1 ")
    List<TBxGzms> getAllByFwdlAndFwfl(@Param("fwdl")Integer fwdl,@Param("fwfl")String fwfl);

    @Query("select t from TBxGzms t where t.fwdl=:fwdl and t.sfqy =1 ")
    List<TBxGzms> getAllByFwdl(@Param("fwdl")Integer fwdl);

    @Query("select t from TBxGzms t where t.fwfl=:fwfl and t.sfqy =1 ")
    List<TBxGzms> getAllByFwfl(@Param("fwfl")String fwfl);

}
